package com.hnhcyy.goods.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.hnhcyy.goods.pojo.SpTestReport;

//商品检验报告
public interface SpTestReportMapper {

	@Insert("insert into sp_test_report(fid,spid,pihao,page) "+
			" values (#{fid},#{spid},#{pihao},#{page})")
	public int insert(SpTestReport item);
	
	@Delete("delete from sp_test_report where fid=#{fid}")
	public int delete(int fid);
	
	@Update("update sp_test_report set spid=#{spid},pihao=#{pihao},page=#{page} "+
			" where fid=#{fid}")
	public int update(SpTestReport item);
	
	@Select("select fid,spid,pihao,page from sp_test_report where fid=#{fid}")
	public SpTestReport select(int fid);
	
	/**
	 * 新增记录
	 * @param spTestReport
	 * @return
	 */
	public int insertSpTestReport(SpTestReport spTestReport);
	
	/**
	 * 查询记录列表
	 * @param queryParam
	 * @return
	 */
	public List<SpTestReport> listSpTestReport(SpTestReport queryParam);
}
